	
/****** Object:  Stored Procedure ResponsiblesUpdate    Script Date: Monday, November 26, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spResponsiblesUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spResponsiblesUpdate]
GO

	
	

	
/******************************************************************************
**		File: 
**		Name: spResponsiblesUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 11/26/2007 11:45:46 AM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spResponsiblesUpdate
	@ResponsibleID int, 
	@Name nvarchar(100), 
	@ConpointID int 
AS

UPDATE [Responsibles] SET
	[Name] = @Name,
	[ConpointID] = @ConpointID
WHERE
	[ResponsibleID] = @ResponsibleID

GO
